/ Linux Programs 1995 Summer / Linux Programs.iso / postgres / postgres.ann

< prev

next >

MacOS 8.1

Win98

DOS

browse contents

view JSON data

view as text

+--------+-------------------------+-------------------------+--------+--------+
|00000000| 46 72 6f 6d 20 77 69 72 | 7a 65 6e 69 75 40 63 63 |From wir|zeniu@cc|
|00000010| 2e 68 65 6c 73 69 6e 6b | 69 2e 66 69 20 57 65 64 |.helsink|i.fi Wed|
|00000020| 20 4d 61 79 20 31 32 20 | 30 39 3a 31 33 3a 34 32 | May 12 |09:13:42|
|00000030| 20 31 39 39 33 0a 44 61 | 74 65 3a 20 54 75 65 2c | 1993.Da|te: Tue,|
|00000040| 20 31 31 20 4d 61 79 20 | 31 39 39 33 20 31 31 3a | 11 May |1993 11:|
|00000050| 32 33 3a 32 38 20 2b 30 | 33 30 30 0a 46 72 6f 6d |23:28 +0|300.From|
|00000060| 3a 20 4c 61 72 73 20 57 | 69 72 7a 65 6e 69 75 73 |: Lars W|irzenius|
|00000070| 20 3c 77 69 72 7a 65 6e | 69 75 40 63 63 2e 68 65 | <wirzen|iu@cc.he|
|00000080| 6c 73 69 6e 6b 69 2e 66 | 69 3e 0a 54 6f 3a 20 6c |lsinki.f|i>.To: l|
|00000090| 69 6e 75 78 2d 61 63 74 | 69 76 69 73 74 73 40 6a |inux-act|ivists@j|
|000000a0| 6f 6b 65 72 2e 63 73 2e | 68 75 74 2e 66 69 0a 53 |oker.cs.|hut.fi.S|
|000000b0| 75 62 6a 65 63 74 3a 20 | 41 4e 4e 4f 55 4e 43 45 |ubject: |ANNOUNCE|
|000000c0| 3a 20 50 6f 73 74 67 72 | 65 73 20 70 6f 72 74 20 |: Postgr|es port |
|000000d0| 74 6f 20 4c 69 6e 75 78 | 0a 0a 0a 0a 46 72 6f 6d |to Linux|....From|
|000000e0| 3a 20 77 70 70 40 6c 69 | 73 65 2e 70 68 79 73 69 |: wpp@li|se.physi|
|000000f0| 6b 2e 74 75 2d 62 65 72 | 6c 69 6e 2e 64 65 20 28 |k.tu-ber|lin.de (|
|00000100| 4b 61 69 20 50 65 74 7a | 6b 65 29 0a 53 75 62 6a |Kai Petz|ke).Subj|
|00000110| 65 63 74 3a 20 41 4e 4e | 4f 55 4e 43 45 3a 20 50 |ect: ANN|OUNCE: P|
|00000120| 6f 73 74 67 72 65 73 20 | 70 6f 72 74 20 74 6f 20 |ostgres |port to |
|00000130| 4c 69 6e 75 78 0a 4f 72 | 67 61 6e 69 7a 61 74 69 |Linux.Or|ganizati|
|00000140| 6f 6e 3a 20 54 55 42 65 | 72 6c 69 6e 2f 5a 52 5a |on: TUBe|rlin/ZRZ|
|00000150| 0a 53 75 6d 6d 61 72 79 | 3a 20 50 6f 72 74 20 6f |.Summary|: Port o|
|00000160| 66 20 50 6f 73 74 67 72 | 65 73 20 74 6f 20 4c 69 |f Postgr|es to Li|
|00000170| 6e 75 78 20 75 70 6c 6f | 61 64 65 64 20 74 6f 20 |nux uplo|aded to |
|00000180| 66 74 70 2e 63 73 2e 74 | 75 2d 62 65 72 6c 69 6e |ftp.cs.t|u-berlin|
|00000190| 2e 64 65 20 61 6e 64 20 | 74 73 78 2d 31 31 0a 4b |.de and |tsx-11.K|
|000001a0| 65 79 77 6f 72 64 73 3a | 20 50 6f 73 74 67 72 65 |eywords:| Postgre|
|000001b0| 73 2c 20 44 61 74 61 62 | 61 73 65 0a 4e 65 77 73 |s, Datab|ase.News|
|000001c0| 67 72 6f 75 70 73 3a 20 | 63 6f 6d 70 2e 6f 73 2e |groups: |comp.os.|
|000001d0| 6c 69 6e 75 78 2e 61 6e | 6e 6f 75 6e 63 65 0a 41 |linux.an|nounce.A|
|000001e0| 70 70 72 6f 76 65 64 3a | 20 6c 69 6e 75 78 2d 61 |pproved:| linux-a|
|000001f0| 6e 6e 6f 75 6e 63 65 40 | 74 63 2e 63 6f 72 6e 65 |nnounce@|tc.corne|
|00000200| 6c 6c 2e 65 64 75 20 28 | 4c 61 72 73 20 57 69 72 |ll.edu (|Lars Wir|
|00000210| 7a 65 6e 69 75 73 29 0a | 46 6f 6c 6c 6f 77 75 70 |zenius).|Followup|
|00000220| 2d 74 6f 3a 20 63 6f 6d | 70 2e 6f 73 2e 6c 69 6e |-to: com|p.os.lin|
|00000230| 75 78 0a 0a 54 68 65 20 | 74 68 65 6d 65 20 22 50 |ux..The |theme "P|
|00000240| 6f 73 74 67 72 65 73 22 | 20 77 61 73 20 64 69 73 |ostgres"| was dis|
|00000250| 63 75 73 73 65 64 20 6d | 6f 72 65 20 74 68 61 6e |cussed m|ore than|
|00000260| 20 6f 6e 63 65 20 6f 6e | 20 63 6f 6d 70 2e 6f 73 | once on| comp.os|
|00000270| 2e 6c 69 6e 75 78 2e 0a | 54 68 65 20 6c 61 73 74 |.linux..|The last|
|00000280| 20 61 72 74 69 63 6c 65 | 20 69 73 20 6f 6e 6c 79 | article| is only|
|00000290| 20 61 20 66 65 77 20 64 | 61 79 73 20 61 67 6f 2e | a few d|ays ago.|
|000002a0| 20 4e 6f 77 20 49 27 6d | 20 70 72 6f 75 64 20 74 | Now I'm| proud t|
|000002b0| 6f 20 61 6e 6e 6f 75 6e | 63 65 0a 74 68 65 20 72 |o announ|ce.the r|
|000002c0| 65 6c 65 61 73 65 20 6f | 66 20 61 20 50 6f 73 74 |elease o|f a Post|
|000002d0| 67 72 65 73 20 50 6f 72 | 74 20 74 6f 20 4c 69 6e |gres Por|t to Lin|
|000002e0| 75 78 2e 0a 0a 49 74 27 | 73 20 66 6f 75 72 20 6d |ux...It'|s four m|
|000002f0| 6f 6e 74 68 73 20 61 67 | 6f 2c 20 74 68 61 74 20 |onths ag|o, that |
|00000300| 49 20 70 6f 73 74 65 64 | 20 74 6f 20 63 2e 6f 2e |I posted| to c.o.|
|00000310| 6c 2c 20 74 68 61 74 20 | 49 20 77 69 6c 6c 20 74 |l, that |I will t|
|00000320| 72 79 20 74 68 65 0a 70 | 6f 72 74 2e 20 49 74 20 |ry the.p|ort. It |
|00000330| 77 61 73 6e 27 74 20 65 | 61 73 79 2c 20 62 75 74 |wasn't e|asy, but|
|00000340| 20 66 69 6e 61 6c 6c 79 | 2c 20 49 20 67 6f 74 20 | finally|, I got |
|00000350| 50 6f 73 74 67 72 65 73 | 20 74 6f 20 70 6c 61 79 |Postgres| to play|
|00000360| 20 61 6c 6c 20 74 68 65 | 0a 64 65 6d 6f 73 20 73 | all the|.demos s|
|00000370| 75 70 70 6c 69 65 64 20 | 77 69 74 68 20 74 68 65 |upplied |with the|
|00000380| 20 73 6f 75 72 63 65 73 | 2e 20 48 6f 77 65 76 65 | sources|. Howeve|
|00000390| 72 2c 20 49 20 64 69 64 | 20 6e 6f 74 20 74 65 73 |r, I did| not tes|
|000003a0| 74 20 74 68 65 0a 50 6f | 73 74 67 72 65 73 20 66 |t the.Po|stgres f|
|000003b0| 69 6c 65 20 73 79 73 74 | 65 6d 20 28 64 6f 65 73 |ile syst|em (does|
|000003c0| 20 4c 69 6e 75 78 20 61 | 74 20 61 6c 6c 20 6e 65 | Linux a|t all ne|
|000003d0| 65 64 20 6d 6f 72 65 20 | 66 69 6c 65 20 73 79 73 |ed more |file sys|
|000003e0| 74 65 6d 73 3f 29 0a 0a | 50 6f 73 74 67 72 65 73 |tems?)..|Postgres|
|000003f0| 20 69 73 20 61 20 72 65 | 6c 61 74 69 6f 6e 61 6c | is a re|lational|
|00000400| 20 64 61 74 61 62 61 73 | 65 20 6d 61 6e 61 67 65 | databas|e manage|
|00000410| 6d 65 6e 74 20 73 79 73 | 74 65 6d 20 6f 66 20 74 |ment sys|tem of t|
|00000420| 68 65 0a 73 75 70 72 65 | 6d 65 20 63 6c 61 73 73 |he.supre|me class|
|00000430| 2e 20 59 6f 75 20 73 68 | 6f 75 6c 64 20 62 65 20 |. You sh|ould be |
|00000440| 61 62 6c 65 20 74 6f 20 | 72 75 6e 20 69 74 20 77 |able to |run it w|
|00000450| 69 74 68 20 34 20 4d 42 | 20 52 41 4d 20 70 6c 75 |ith 4 MB| RAM plu|
|00000460| 73 0a 73 6f 6d 65 20 73 | 77 61 70 20 28 75 6e 76 |s.some s|wap (unv|
|00000470| 65 72 69 66 69 65 64 20 | 62 79 20 6d 65 2c 20 70 |erified |by me, p|
|00000480| 6c 65 61 73 65 20 74 65 | 6c 6c 20 6d 65 2c 20 69 |lease te|ll me, i|
|00000490| 66 20 49 20 77 61 73 20 | 77 72 6f 6e 67 29 2e 0a |f I was |wrong)..|
|000004a0| 59 6f 75 20 6e 65 65 64 | 20 37 20 4d 42 20 48 61 |You need| 7 MB Ha|
|000004b0| 72 64 64 69 73 6b 20 73 | 70 61 63 65 20 66 6f 72 |rddisk s|pace for|
|000004c0| 20 61 6c 6c 20 74 68 65 | 20 64 65 6d 6f 73 2c 20 | all the| demos, |
|000004d0| 74 68 65 20 63 6f 6d 70 | 6c 65 74 65 0a 64 6f 63 |the comp|lete.doc|
|000004e0| 75 6d 65 6e 74 61 74 69 | 6f 6e 20 61 6e 64 20 74 |umentati|on and t|
|000004f0| 68 65 20 62 69 6e 61 72 | 69 65 73 2e 0a 0a 49 6e |he binar|ies...In|
|00000500| 20 6f 72 64 65 72 20 74 | 6f 20 72 75 6e 20 50 6f | order t|o run Po|
|00000510| 73 74 67 72 65 73 2c 20 | 79 6f 75 20 6e 65 65 64 |stgres, |you need|
|00000520| 20 74 68 65 20 49 50 43 | 20 70 61 63 6b 61 67 65 | the IPC| package|
|00000530| 20 63 6f 6d 70 69 6c 65 | 64 20 69 6e 74 6f 0a 79 | compile|d into.y|
|00000540| 6f 75 72 20 6b 65 72 6e | 65 6c 2e 20 50 6c 65 61 |our kern|el. Plea|
|00000550| 73 65 20 72 65 66 65 72 | 20 74 6f 20 74 68 65 20 |se refer| to the |
|00000560| 70 6f 73 74 67 72 65 73 | 2e 52 45 41 44 4d 45 20 |postgres|.README |
|00000570| 66 6f 72 20 64 65 74 61 | 69 6c 73 2e 0a 49 74 20 |for deta|ils..It |
|00000580| 63 6f 6e 74 61 69 6e 73 | 20 6d 75 63 68 20 6d 6f |contains| much mo|
|00000590| 72 65 20 75 73 65 66 75 | 6c 20 69 6e 66 6f 72 6d |re usefu|l inform|
|000005a0| 61 74 69 6f 6e 2c 20 74 | 6f 6f 2c 20 73 6f 20 64 |ation, t|oo, so d|
|000005b0| 6f 6e 27 74 20 66 6f 72 | 67 65 74 0a 74 6f 20 67 |on't for|get.to g|
|000005c0| 65 74 20 69 74 20 77 69 | 74 68 20 70 6f 73 74 67 |et it wi|th postg|
|000005d0| 72 65 73 2e 0a 0a 50 6f | 73 74 67 72 65 73 20 69 |res...Po|stgres i|
|000005e0| 73 20 73 75 70 70 6c 69 | 65 64 20 62 6f 74 68 20 |s suppli|ed both |
|000005f0| 73 6f 75 72 63 65 20 61 | 6e 64 20 62 69 6e 61 72 |source a|nd binar|
|00000600| 79 2e 20 49 20 68 61 76 | 65 20 75 70 6c 6f 61 64 |y. I hav|e upload|
|00000610| 65 64 20 69 74 0a 74 6f | 20 74 68 65 20 6c 69 6e |ed it.to| the lin|
|00000620| 75 78 20 69 6e 63 6f 6d | 69 6e 67 20 64 69 72 65 |ux incom|ing dire|
|00000630| 63 74 6f 72 69 65 73 20 | 6f 66 3a 0a 74 73 78 2d |ctories |of:.tsx-|
|00000640| 31 31 2e 6d 69 74 2e 65 | 64 75 0a 66 74 70 2e 63 |11.mit.e|du.ftp.c|
|00000650| 73 2e 74 75 2d 62 65 72 | 6c 69 6e 2e 64 65 0a 0a |s.tu-ber|lin.de..|
|00000660| 59 6f 75 20 77 69 6c 6c | 20 68 61 76 65 20 74 6f |You will| have to|
|00000670| 20 77 61 69 74 2c 20 75 | 6e 74 69 6c 20 74 68 65 | wait, u|ntil the|
|00000680| 20 6c 6f 63 61 6c 20 73 | 79 73 6f 70 73 20 70 72 | local s|ysops pr|
|00000690| 6f 63 65 73 73 20 74 68 | 65 73 65 20 66 69 6c 65 |ocess th|ese file|
|000006a0| 73 2e 0a 41 74 20 6c 65 | 61 73 74 20 61 74 20 74 |s..At le|ast at t|
|000006b0| 73 78 2d 31 31 2e 6d 69 | 74 2e 65 64 75 2c 20 74 |sx-11.mi|t.edu, t|
|000006c0| 68 65 20 2f 69 6e 63 6f | 6d 69 6e 67 20 64 69 72 |he /inco|ming dir|
|000006d0| 65 63 74 6f 72 79 20 69 | 73 20 6e 6f 74 20 72 65 |ectory i|s not re|
|000006e0| 61 64 61 62 6c 65 0a 62 | 79 20 74 68 65 20 22 77 |adable.b|y the "w|
|000006f0| 6f 72 6c 64 22 2e 0a 0a | 45 78 63 65 72 70 74 73 |orld"...|Excerpts|
|00000700| 20 66 72 6f 6d 20 74 68 | 65 20 70 6f 73 74 67 72 | from th|e postgr|
|00000710| 65 73 2e 52 45 41 44 4d | 45 3a 0a 0a 51 3a 20 57 |es.READM|E:..Q: W|
|00000720| 68 69 63 68 20 70 61 63 | 6b 61 67 65 73 20 64 6f |hich pac|kages do|
|00000730| 20 49 20 6e 65 65 64 3f | 0a 2d 2d 2d 2d 2d 2d 2d | I need?|.-------|
|00000740| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000750| 2d 2d 2d 2d 2d 0a 70 6f | 73 74 67 72 65 73 34 2e |-----.po|stgres4.|
|00000760| 30 2e 31 61 2e 64 6f 63 | 2e 74 61 72 2e 7a 3a 20 |0.1a.doc|.tar.z: |
|00000770| 20 20 64 6f 63 75 6d 65 | 6e 74 61 74 69 6f 6e 2c |  docume|ntation,|
|00000780| 20 67 65 74 20 69 74 2e | 0a 70 6f 73 74 67 72 65 | get it.|.postgre|
|00000790| 73 34 2e 30 2e 31 61 2e | 64 65 6d 6f 2e 74 61 72 |s4.0.1a.|demo.tar|
|000007a0| 2e 7a 3a 20 20 64 65 6d | 6f 73 2c 20 67 65 74 20 |.z:  dem|os, get |
|000007b0| 74 68 65 6d 2e 0a 70 6f | 73 74 67 72 65 73 34 2e |them..po|stgres4.|
|000007c0| 30 2e 31 61 2e 62 69 6e | 2e 74 61 72 2e 7a 3a 20 |0.1a.bin|.tar.z: |
|000007d0| 20 20 62 69 6e 61 72 69 | 65 73 2e 0a 70 6f 73 74 |  binari|es..post|
|000007e0| 67 72 65 73 34 2e 30 2e | 31 61 2e 6c 69 62 70 71 |gres4.0.|1a.libpq|
|000007f0| 2e 74 61 72 2e 7a 3a 20 | 6c 69 62 72 61 72 69 65 |.tar.z: |librarie|
|00000800| 73 20 66 6f 72 20 61 70 | 70 6c 69 63 61 74 69 6f |s for ap|plicatio|
|00000810| 6e 20 64 65 76 65 6c 6f | 70 6d 65 6e 74 2e 0a 70 |n develo|pment..p|
|00000820| 6f 73 74 67 72 65 73 34 | 2e 30 2e 31 61 2e 73 72 |ostgres4|.0.1a.sr|
|00000830| 63 2e 74 61 72 2e 7a 3a | 20 20 20 54 68 65 20 73 |c.tar.z:|   The s|
|00000840| 6f 75 72 63 65 20 63 6f | 64 65 2c 20 6f 66 20 63 |ource co|de, of c|
|00000850| 6f 75 72 73 65 2e 0a 0a | 59 6f 75 20 6e 65 65 64 |ourse...|You need|
|00000860| 20 74 68 65 20 6c 69 62 | 70 71 20 70 61 63 6b 61 | the lib|pq packa|
|00000870| 67 65 2c 20 69 66 20 79 | 6f 75 20 77 61 6e 74 20 |ge, if y|ou want |
|00000880| 74 6f 20 61 63 63 65 73 | 73 20 74 68 65 20 64 61 |to acces|s the da|
|00000890| 74 61 62 61 73 65 0a 66 | 72 6f 6d 20 43 20 63 6f |tabase.f|rom C co|
|000008a0| 64 65 2e 20 49 74 20 63 | 6f 6e 74 61 69 6e 73 20 |de. It c|ontains |
|000008b0| 61 6c 6c 20 67 6c 6f 62 | 61 6c 20 68 65 61 64 65 |all glob|al heade|
|000008c0| 72 20 66 69 6c 65 73 2c | 20 61 73 20 77 65 6c 6c |r files,| as well|
|000008d0| 20 61 73 20 74 68 65 0a | 73 74 61 74 69 63 20 6c | as the.|static l|
|000008e0| 69 62 70 71 2e 61 20 6c | 69 62 72 61 72 79 2e 20 |ibpq.a l|ibrary. |
|000008f0| 59 6f 75 20 64 6f 6e 27 | 74 20 6e 65 65 64 20 74 |You don'|t need t|
|00000900| 68 69 73 20 70 61 63 6b | 61 67 65 2c 20 69 66 20 |his pack|age, if |
|00000910| 79 6f 75 20 67 65 74 0a | 74 68 65 20 73 6f 75 72 |you get.|the sour|
|00000920| 63 65 2e 0a 0a 56 65 72 | 73 69 6f 6e 20 73 75 6d |ce...Ver|sion sum|
|00000930| 6d 61 72 79 0a 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |mary.---|--------|
|00000940| 2d 2d 2d 2d 0a 50 6f 73 | 74 67 72 65 73 3a 09 34 |----.Pos|tgres:.4|
|00000950| 2e 30 2e 31 0a 54 68 69 | 73 20 70 6f 72 74 3a 09 |.0.1.Thi|s port:.|
|00000960| 30 2e 31 0a 4c 69 6e 75 | 78 20 4b 65 72 6e 65 6c |0.1.Linu|x Kernel|
|00000970| 3a 09 30 2e 39 39 2e 37 | 20 6f 72 20 68 69 67 68 |:.0.99.7| or high|
|00000980| 65 72 20 28 66 6f 72 20 | 49 50 43 44 45 4c 54 41 |er (for |IPCDELTA|
|00000990| 29 0a 49 50 43 3a 09 09 | 44 65 6c 74 61 0a 53 68 |).IPC:..|Delta.Sh|
|000009a0| 61 72 65 64 20 4c 69 62 | 73 3a 09 34 2e 33 2e 33 |ared Lib|s:.4.3.3|
|000009b0| 0a 0a 51 3a 20 57 68 61 | 74 20 69 73 20 50 6f 73 |..Q: Wha|t is Pos|
|000009c0| 74 67 72 65 73 3f 0a 2d | 2d 2d 2d 2d 2d 2d 2d 2d |tgres?.-|--------|
|000009d0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 0a 50 6f 73 74 |--------|---.Post|
|000009e0| 67 72 65 73 20 69 73 20 | 61 20 72 65 6c 61 74 69 |gres is |a relati|
|000009f0| 6f 6e 61 6c 20 64 61 74 | 61 62 61 73 65 20 6d 61 |onal dat|abase ma|
|00000a00| 6e 61 67 65 6d 65 6e 74 | 20 73 79 73 74 65 6d 2e |nagement| system.|
|00000a10| 20 49 74 20 68 61 73 20 | 6d 61 6e 79 0a 6f 66 20 | It has |many.of |
|00000a20| 6e 65 77 20 69 64 65 61 | 73 20 69 6e 70 6c 65 6d |new idea|s inplem|
|00000a30| 65 6e 74 65 64 2c 20 61 | 6d 6f 6e 67 20 74 68 65 |ented, a|mong the|
|00000a40| 6d 20 61 72 65 3a 0a 0a | 2d 20 64 79 6e 61 6d 69 |m are:..|- dynami|
|00000a50| 63 20 6c 6f 61 64 69 6e | 67 20 6f 66 20 64 61 74 |c loadin|g of dat|
|00000a60| 61 74 79 70 65 73 20 61 | 6e 64 20 66 75 6e 63 74 |atypes a|nd funct|
|00000a70| 69 6f 6e 73 20 69 6e 74 | 6f 20 74 68 65 20 64 61 |ions int|o the da|
|00000a80| 74 61 62 61 73 65 0a 20 | 20 28 66 6f 72 20 65 78 |tabase. | (for ex|
|00000a90| 61 6d 70 6c 65 2c 20 79 | 6f 75 20 63 6f 75 6c 64 |ample, y|ou could|
|00000aa0| 20 64 65 66 69 6e 65 20 | 63 6f 6d 70 6c 65 78 20 | define |complex |
|00000ab0| 6e 75 6d 62 65 72 73 20 | 61 73 20 64 61 74 61 74 |numbers |as datat|
|00000ac0| 79 70 65 73 2c 0a 20 20 | 70 72 6f 76 69 64 65 20 |ypes,.  |provide |
|00000ad0| 61 6c 6c 20 74 68 65 20 | 66 75 6e 63 74 69 6f 6e |all the |function|
|00000ae0| 20 66 6f 72 20 63 6f 6d | 70 6c 65 78 20 61 72 69 | for com|plex ari|
|00000af0| 74 68 6d 65 74 69 63 73 | 2c 20 61 6e 64 20 74 68 |thmetics|, and th|
|00000b00| 65 6e 0a 20 20 72 65 74 | 72 69 65 76 65 20 61 6c |en.  ret|rieve al|
|00000b10| 6c 20 72 65 63 6f 72 64 | 73 2c 20 77 68 65 72 65 |l record|s, where|
|00000b20| 20 74 68 65 20 61 62 73 | 6f 6c 75 74 65 20 76 61 | the abs|olute va|
|00000b30| 6c 75 65 20 6f 66 20 74 | 68 65 20 65 78 70 6f 6e |lue of t|he expon|
|00000b40| 65 6e 74 0a 20 20 6f 66 | 20 6f 6e 65 20 66 69 65 |ent.  of| one fie|
|00000b50| 6c 64 20 69 73 20 62 69 | 67 67 65 72 20 74 68 61 |ld is bi|gger tha|
|00000b60| 6e 20 61 20 67 69 76 65 | 6e 20 76 61 6c 75 65 20 |n a give|n value |
|00000b70| 2e 2e 2e 29 2e 0a 0a 2d | 20 41 20 74 72 61 6e 73 |...)...-| A trans|
|00000b80| 61 63 74 69 6f 6e 20 6c | 65 76 65 6c 20 72 75 6c |action l|evel rul|
|00000b90| 65 20 73 79 73 74 65 6d | 20 28 73 61 79 20 79 6f |e system| (say yo|
|00000ba0| 75 20 67 6f 74 20 74 77 | 6f 20 72 65 6c 61 74 69 |u got tw|o relati|
|00000bb0| 6f 6e 73 0a 20 20 28 3d | 20 64 61 74 61 62 61 73 |ons.  (=| databas|
|00000bc0| 65 20 74 61 62 6c 65 73 | 29 2c 20 6f 6e 65 20 63 |e tables|), one c|
|00000bd0| 6f 6e 74 61 69 6e 69 6e | 67 20 74 68 65 20 61 63 |ontainin|g the ac|
|00000be0| 63 6f 75 6e 74 73 20 77 | 69 74 68 20 74 68 65 0a |counts w|ith the.|
|00000bf0| 20 20 74 6f 74 61 6c 73 | 2c 20 6f 6e 65 20 77 69 |  totals|, one wi|
|00000c00| 74 68 20 74 68 65 20 62 | 6f 6f 6b 69 6e 67 73 2e |th the b|ookings.|
|00000c10| 20 59 6f 75 20 63 6f 75 | 6c 64 20 74 68 65 6e 20 | You cou|ld then |
|00000c20| 77 72 69 74 65 20 61 20 | 72 75 6c 65 2c 0a 20 20 |write a |rule,.  |
|00000c30| 74 68 61 74 20 61 6c 77 | 61 79 73 20 75 70 64 61 |that alw|ays upda|
|00000c40| 74 65 73 20 74 68 65 20 | 74 6f 74 61 6c 73 2c 20 |tes the |totals, |
|00000c50| 77 68 65 6e 20 61 20 6e | 65 77 20 62 6f 6f 6b 69 |when a n|ew booki|
|00000c60| 6e 67 20 69 73 20 69 6e | 73 65 72 74 65 64 29 2e |ng is in|serted).|
|00000c70| 0a 0a 2d 20 41 20 74 72 | 61 6e 73 70 61 72 65 6e |..- A tr|ansparen|
|00000c80| 74 20 68 69 73 74 6f 72 | 79 20 73 79 73 74 65 6d |t histor|y system|
|00000c90| 2c 20 73 6f 20 79 6f 75 | 20 63 61 6e 20 71 75 65 |, so you| can que|
|00000ca0| 72 79 20 74 68 65 20 73 | 74 61 74 65 20 6f 66 0a |ry the s|tate of.|
|00000cb0| 20 20 74 68 65 20 64 61 | 74 61 62 61 73 65 20 61 |  the da|tabase a|
|00000cc0| 74 20 61 6e 79 20 74 69 | 6d 65 20 69 6e 20 74 68 |t any ti|me in th|
|00000cd0| 65 20 70 61 73 74 20 28 | 75 6e 6c 65 73 73 20 79 |e past (|unless y|
|00000ce0| 6f 75 20 75 73 65 20 74 | 68 65 0a 20 20 76 61 63 |ou use t|he.  vac|
|00000cf0| 75 75 6d 20 63 6c 65 61 | 6e 65 72 2c 20 77 68 69 |uum clea|ner, whi|
|00000d00| 63 68 20 73 6c 75 72 70 | 73 20 75 70 20 61 6c 6c |ch slurp|s up all|
|00000d10| 20 74 68 65 20 6f 75 74 | 64 61 74 65 64 20 73 74 | the out|dated st|
|00000d20| 75 66 66 20 2e 2e 2e 29 | 2e 0a 0a 2d 20 53 75 70 |uff ...)|...- Sup|
|00000d30| 70 6f 72 74 20 66 6f 72 | 20 57 72 69 74 65 20 4f |port for| Write O|
|00000d40| 6e 63 65 2c 20 52 65 61 | 64 20 4d 75 6c 74 69 70 |nce, Rea|d Multip|
|00000d50| 6c 65 20 28 57 4f 52 4d | 29 20 73 74 6f 72 61 67 |le (WORM|) storag|
|00000d60| 65 20 64 65 76 69 63 65 | 73 2e 0a 0a 2d 20 4d 61 |e device|s...- Ma|
|00000d70| 6e 79 2c 20 6d 61 6e 79 | 20 6f 74 68 65 72 73 20 |ny, many| others |
|00000d80| 2e 2e 2e 0a 0a 51 3a 20 | 53 70 61 63 65 20 72 65 |.....Q: |Space re|
|00000d90| 71 75 69 72 65 6d 65 6e | 74 73 3f 0a 2d 2d 2d 2d |quiremen|ts?.----|
|00000da0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000db0| 2d 2d 0a 42 69 6e 61 72 | 69 65 73 3a 09 32 20 4d |--.Binar|ies:.2 M|
|00000dc0| 42 20 48 44 20 53 70 61 | 63 65 20 2b 20 44 61 74 |B HD Spa|ce + Dat|
|00000dd0| 61 62 61 73 65 20 73 70 | 61 63 65 0a 09 09 34 20 |abase sp|ace...4 |
|00000de0| 4d 42 20 52 41 4d 20 2b | 20 73 6f 6d 65 20 73 77 |MB RAM +| some sw|
|00000df0| 61 70 2c 20 69 66 20 6e | 6f 74 68 69 6e 67 20 65 |ap, if n|othing e|
|00000e00| 6c 73 65 20 69 73 20 72 | 75 6e 6e 69 6e 67 2e 0a |lse is r|unning..|
|00000e10| 09 09 28 6d 61 79 62 65 | 20 6d 6f 72 65 2c 20 49 |..(maybe| more, I|
|00000e20| 20 68 61 76 65 20 38 20 | 4d 42 20 61 6e 64 20 64 | have 8 |MB and d|
|00000e30| 69 64 20 6e 6f 74 20 74 | 65 73 74 20 77 69 74 68 |id not t|est with|
|00000e40| 20 34 29 0a 0a 44 6f 63 | 73 3a 09 09 61 29 20 74 | 4)..Doc|s:..a) t|
|00000e50| 72 6f 66 66 20 73 6f 75 | 72 63 65 3a 20 20 20 20 |roff sou|rce:    |
|00000e60| 32 20 4d 42 20 48 44 0a | 09 09 62 29 20 70 6f 73 |2 MB HD.|..b) pos|
|00000e70| 74 73 63 72 69 70 74 20 | 64 75 6d 70 3a 20 32 20 |tscript |dump: 2 |
|00000e80| 4d 42 20 48 44 0a 0a 45 | 78 63 65 72 70 74 73 20 |MB HD..E|xcerpts |
|00000e90| 66 72 6f 6d 20 74 68 65 | 20 70 6f 73 74 67 72 65 |from the| postgre|
|00000ea0| 73 2e 46 41 51 3a 0a 2d | 2d 2d 2d 2d 2d 2d 2d 2d |s.FAQ:.-|--------|
|00000eb0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000ec0| 2d 2d 2d 2d 2d 2d 0a 51 | 2e 20 20 57 68 61 74 20 |------.Q|.  What |
|00000ed0| 69 73 20 74 68 65 20 63 | 6f 6e 6e 65 63 74 69 6f |is the c|onnectio|
|00000ee0| 6e 20 62 65 74 77 65 65 | 6e 20 50 6f 73 74 67 72 |n betwee|n Postgr|
|00000ef0| 65 73 20 61 6e 64 20 49 | 6e 67 72 65 73 3f 0a 0a |es and I|ngres?..|
|00000f00| 41 2e 20 20 54 68 65 72 | 65 20 69 73 20 6e 6f 6e |A.  Ther|e is non|
|00000f10| 65 2c 20 61 73 69 64 65 | 20 66 72 6f 6d 20 50 72 |e, aside| from Pr|
|00000f20| 6f 66 2e 20 53 74 6f 6e | 65 62 72 61 6b 65 72 2e |of. Ston|ebraker.|
|00000f30| 20 20 54 68 65 72 65 20 | 69 73 20 6e 6f 20 63 6f |  There |is no co|
|00000f40| 6d 70 61 74 69 62 69 6c | 69 74 79 0a 20 20 20 20 |mpatibil|ity.    |
|00000f50| 62 65 74 77 65 65 6e 20 | 74 68 65 20 74 77 6f 20 |between |the two |
|00000f60| 73 6f 66 74 77 61 72 65 | 20 70 61 63 6b 61 67 65 |software| package|
|00000f70| 73 2c 20 61 6e 64 20 74 | 68 65 20 72 65 73 65 61 |s, and t|he resea|
|00000f80| 72 63 68 20 70 72 6f 6a | 65 63 74 73 20 68 61 76 |rch proj|ects hav|
|00000f90| 65 0a 20 20 20 20 64 69 | 66 66 65 72 69 6e 67 20 |e.    di|ffering |
|00000fa0| 6f 62 6a 65 63 74 69 76 | 65 73 2e 20 20 57 65 20 |objectiv|es.  We |
|00000fb0| 64 6f 20 6e 6f 74 20 73 | 75 70 70 6f 72 74 20 55 |do not s|upport U|
|00000fc0| 6e 69 76 65 72 73 69 74 | 79 20 49 6e 67 72 65 73 |niversit|y Ingres|
|00000fd0| 20 61 74 20 61 6c 6c 3b | 0a 20 20 20 20 71 75 65 | at all;|.    que|
|00000fe0| 73 74 69 6f 6e 73 20 61 | 62 6f 75 74 20 69 74 20 |stions a|bout it |
|00000ff0| 73 68 6f 75 6c 64 20 62 | 65 20 73 65 6e 74 20 74 |should b|e sent t|
|00001000| 6f 20 74 68 65 20 55 53 | 45 4e 45 54 20 67 72 6f |o the US|ENET gro|
|00001010| 75 70 20 22 63 6f 6d 70 | 2e 64 61 74 61 62 61 73 |up "comp|.databas|
|00001020| 65 73 22 2e 0a 0a 51 2e | 20 20 57 68 61 74 20 69 |es"...Q.|  What i|
|00001030| 73 20 74 68 65 20 50 6f | 73 74 67 72 65 73 20 71 |s the Po|stgres q|
|00001040| 75 65 72 79 20 6c 61 6e | 67 75 61 67 65 3f 0a 0a |uery lan|guage?..|
|00001050| 41 2e 20 20 50 6f 73 74 | 71 75 65 6c 2c 20 77 68 |A.  Post|quel, wh|
|00001060| 69 63 68 20 69 73 20 61 | 6e 20 69 6e 63 6f 6d 70 |ich is a|n incomp|
|00001070| 61 74 69 62 6c 65 20 73 | 75 70 65 72 73 65 74 20 |atible s|uperset |
|00001080| 6f 66 20 51 75 65 6c 2e | 0a 0a 51 2e 20 20 57 68 |of Quel.|..Q.  Wh|
|00001090| 61 74 20 61 62 6f 75 74 | 20 53 51 4c 20 73 75 70 |at about| SQL sup|
|000010a0| 70 6f 72 74 3f 0a 0a 41 | 2e 20 20 57 65 20 64 6f |port?..A|.  We do|
|000010b0| 20 6e 6f 74 20 73 75 70 | 70 6f 72 74 20 53 51 4c | not sup|port SQL|
|000010c0| 20 61 74 20 74 68 69 73 | 20 74 69 6d 65 2e 0a 0a | at this| time...|
|000010d0| 51 2e 20 20 57 68 61 74 | 20 64 6f 65 73 20 50 6f |Q.  What| does Po|
|000010e0| 73 74 67 72 65 73 20 72 | 75 6e 20 6f 6e 3f 0a 0a |stgres r|un on?..|
|000010f0| 51 2e 20 20 57 68 61 74 | 20 69 73 20 74 68 65 20 |Q.  What| is the |
|00001100| 73 74 61 74 75 73 20 6f | 66 20 74 68 65 20 50 6f |status o|f the Po|
|00001110| 73 74 67 72 65 73 20 69 | 6d 70 6c 65 6d 65 6e 74 |stgres i|mplement|
|00001120| 61 74 69 6f 6e 3f 0a 0a | 41 2e 20 20 49 74 20 69 |ation?..|A.  It i|
|00001130| 73 20 6e 6f 74 20 75 70 | 20 74 6f 20 63 6f 6d 6d |s not up| to comm|
|00001140| 65 72 63 69 61 6c 20 6c | 65 76 65 6c 73 20 6f 66 |ercial l|evels of|
|00001150| 20 72 65 6c 69 61 62 69 | 6c 69 74 79 2e 20 20 49 | reliabi|lity.  I|
|00001160| 20 77 6f 75 6c 64 20 6e | 6f 74 20 77 61 6e 74 0a | would n|ot want.|
|00001170| 20 20 20 20 5f 6d 79 5f | 20 70 61 79 72 6f 6c 6c |    _my_| payroll|
|00001180| 20 72 65 63 6f 72 64 73 | 20 69 6e 20 69 74 20 3a | records| in it :|
|00001190| 2d 29 20 20 48 6f 77 65 | 76 65 72 2c 20 69 74 20 |-)  Howe|ver, it |
|000011a0| 69 73 20 71 75 69 74 65 | 20 61 64 61 71 75 61 74 |is quite| adaquat|
|000011b0| 65 20 66 6f 72 0a 20 20 | 20 20 6d 61 6e 61 67 69 |e for.  |  managi|
|000011c0| 6e 67 20 73 63 69 65 6e | 74 69 66 69 63 20 61 6e |ng scien|tific an|
|000011d0| 64 20 65 78 70 65 72 69 | 6d 65 6e 74 61 6c 20 64 |d experi|mental d|
|000011e0| 61 74 61 73 65 74 73 20 | 61 6e 64 20 61 73 20 61 |atasets |and as a|
|000011f0| 6e 20 69 6e 73 74 72 75 | 63 74 69 6f 6e 61 6c 0a |n instru|ctional.|
|00001200| 20 20 20 20 73 79 73 74 | 65 6d 2e 20 20 49 74 73 |    syst|em.  Its|
|00001210| 20 73 70 65 65 64 20 6f | 6e 20 61 70 70 6c 69 63 | speed o|n applic|
|00001220| 61 74 69 6f 6e 73 20 77 | 68 69 63 68 20 73 74 72 |ations w|hich str|
|00001230| 65 73 73 20 74 72 61 6e | 73 61 63 74 69 6f 6e 20 |ess tran|saction |
|00001240| 70 72 6f 63 65 73 73 69 | 6e 67 0a 20 20 20 20 69 |processi|ng.    i|
|00001250| 73 20 6e 6f 74 20 70 61 | 72 74 69 63 75 6c 61 72 |s not pa|rticular|
|00001260| 6c 79 20 67 6f 6f 64 2c | 20 62 75 74 20 69 74 20 |ly good,| but it |
|00001270| 69 73 20 77 69 74 68 69 | 6e 20 61 62 6f 75 74 20 |is withi|n about |
|00001280| 35 30 25 20 6f 66 20 63 | 6f 6d 6d 65 72 63 69 61 |50% of c|ommercia|
|00001290| 6c 20 73 79 73 74 65 6d | 73 0a 20 20 20 20 6f 6e |l system|s.    on|
|000012a0| 20 74 68 65 20 6d 6f 72 | 65 20 22 72 65 70 6f 72 | the mor|e "repor|
|000012b0| 74 2d 6f 72 69 65 6e 74 | 65 64 22 20 57 69 73 63 |t-orient|ed" Wisc|
|000012c0| 6f 6e 73 69 6e 20 62 65 | 6e 63 68 6d 61 72 6b 2c |onsin be|nchmark,|
|000012d0| 20 61 6e 64 20 69 73 20 | 74 77 69 63 65 20 61 73 | and is |twice as|
|000012e0| 20 66 61 73 74 0a 20 20 | 20 20 61 73 20 55 6e 69 | fast.  |  as Uni|
|000012f0| 76 65 72 73 69 74 79 20 | 49 6e 67 72 65 73 20 6f |versity |Ingres o|
|00001300| 6e 20 74 68 65 20 57 69 | 73 63 6f 6e 73 69 6e 2e |n the Wi|sconsin.|
|00001310| 0a 0a 42 75 67 73 3a 0a | 2d 2d 2d 2d 2d 0a 54 68 |..Bugs:.|-----.Th|
|00001320| 65 20 50 6f 73 74 67 72 | 65 73 20 56 34 2e 30 2e |e Postgr|es V4.0.|
|00001330| 31 20 77 61 73 20 6f 6e | 6c 79 20 61 20 62 75 67 |1 was on|ly a bug|
|00001340| 20 66 69 78 20 72 65 6c | 65 61 73 65 20 72 65 6c | fix rel|ease rel|
|00001350| 61 74 69 76 65 20 74 6f | 20 34 2e 30 2c 0a 73 6f |ative to| 4.0,.so|
|00001360| 20 64 6f 6e 27 74 20 62 | 65 6c 69 65 76 65 2c 20 | don't b|elieve, |
|00001370| 79 6f 75 20 77 69 6c 6c | 20 68 61 76 65 20 61 20 |you will| have a |
|00001380| 72 6f 62 75 73 74 20 64 | 61 74 61 62 61 73 65 20 |robust d|atabase |
|00001390| 73 79 73 74 65 6d 20 77 | 69 74 68 20 74 68 69 73 |system w|ith this|
|000013a0| 0a 76 65 72 73 69 6f 6e | 20 6f 66 20 50 6f 73 74 |.version| of Post|
|000013b0| 67 72 65 73 2e 20 41 6c | 73 6f 20 6e 6f 74 65 2c |gres. Al|so note,|
|000013c0| 20 74 68 61 74 20 74 68 | 69 73 20 70 6f 72 74 20 | that th|is port |
|000013d0| 69 73 20 61 6e 20 41 4c | 50 48 41 20 72 65 6c 65 |is an AL|PHA rele|
|000013e0| 61 73 65 2e 0a 48 6f 77 | 65 76 65 72 2c 20 74 68 |ase..How|ever, th|
|000013f0| 65 72 65 20 61 72 65 20 | 6e 6f 20 62 75 67 73 20 |ere are |no bugs |
|00001400| 6b 6e 6f 77 6e 20 74 6f | 20 6d 65 2c 20 61 70 61 |known to| me, apa|
|00001410| 72 74 20 74 68 6f 73 65 | 20 6d 65 6e 74 69 6f 6e |rt those| mention|
|00001420| 65 64 20 69 6e 0a 64 6f | 63 2f 72 65 6c 65 61 73 |ed in.do|c/releas|
|00001430| 65 2e 34 2e 30 2e 31 2e | 20 49 20 74 72 69 65 64 |e.4.0.1.| I tried|
|00001440| 20 6d 79 20 62 65 73 74 | 20 74 6f 20 6d 61 6b 65 | my best| to make|
|00001450| 20 74 68 69 73 20 70 6f | 72 74 20 63 6c 65 61 6e | this po|rt clean|
|00001460| 2c 20 62 75 74 20 69 66 | 0a 79 6f 75 20 66 69 6e |, but if|.you fin|
|00001470| 64 20 62 75 67 73 2c 20 | 70 6c 65 61 73 65 20 65 |d bugs, |please e|
|00001480| 2d 6d 61 69 6c 20 74 6f | 3a 0a 0a 4b 61 69 20 50 |-mail to|:..Kai P|
|00001490| 65 74 7a 6b 65 2c 20 77 | 70 70 40 6d 61 72 69 65 |etzke, w|pp@marie|
|000014a0| 2e 70 68 79 73 69 6b 2e | 74 75 2d 62 65 72 6c 69 |.physik.|tu-berli|
|000014b0| 6e 2e 64 65 0a 0a 51 75 | 65 73 74 69 6f 6e 73 2c |n.de..Qu|estions,|
|000014c0| 20 50 72 6f 62 6c 65 6d | 73 3a 0a 2d 2d 2d 2d 2d | Problem|s:.-----|
|000014d0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 0a |--------|-------.|
|000014e0| 46 65 65 6c 20 66 72 65 | 65 20 74 6f 20 61 73 6b |Feel fre|e to ask|
|000014f0| 2c 20 62 75 74 20 70 6c | 65 61 73 65 20 72 65 61 |, but pl|ease rea|
|00001500| 64 20 74 68 69 73 20 72 | 65 61 64 6d 65 2c 20 74 |d this r|eadme, t|
|00001510| 68 65 20 4c 69 6e 75 78 | 27 20 46 41 51 73 0a 61 |he Linux|' FAQs.a|
|00001520| 6e 64 20 70 6f 73 74 67 | 72 65 73 2d 73 65 74 75 |nd postg|res-setu|
|00001530| 70 2e 6d 65 20 62 65 66 | 6f 72 65 20 79 6f 75 20 |p.me bef|ore you |
|00001540| 62 6f 6d 62 20 6d 65 20 | 77 69 74 68 20 65 2d 6d |bomb me |with e-m|
|00001550| 61 69 6c 2e 20 50 6c 65 | 61 73 65 20 62 65 0a 70 |ail. Ple|ase be.p|
|00001560| 61 74 69 65 6e 74 2c 20 | 49 20 72 65 61 64 20 65 |atient, |I read e|
|00001570| 2d 6d 61 69 6c 20 74 77 | 6f 20 6f 72 20 74 68 72 |-mail tw|o or thr|
|00001580| 65 65 20 74 69 6d 65 73 | 20 61 20 77 65 65 6b 20 |ee times| a week |
|00001590| 6f 6e 6c 79 2e 0a 0a 46 | 75 74 75 72 65 20 50 6c |only...F|uture Pl|
|000015a0| 61 6e 73 3a 0a 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |ans:.---|--------|
|000015b0| 2d 2d 0a 31 29 20 4d 61 | 6b 65 20 74 68 69 73 20 |--.1) Ma|ke this |
|000015c0| 70 6f 72 74 20 73 74 61 | 62 6c 65 2e 0a 32 29 20 |port sta|ble..2) |
|000015d0| 50 6f 72 74 20 70 69 63 | 61 73 73 6f 2c 20 74 68 |Port pic|asso, th|
|000015e0| 65 20 67 72 61 70 68 69 | 63 61 6c 20 66 72 6f 6e |e graphi|cal fron|
|000015f0| 74 2d 65 6e 64 20 75 6e | 64 65 72 20 58 2e 0a 33 |t-end un|der X..3|
|00001600| 29 20 55 70 67 72 61 64 | 65 20 74 6f 20 74 68 65 |) Upgrad|e to the|
|00001610| 20 6e 65 77 65 72 20 70 | 6f 73 74 67 72 65 73 20 | newer p|ostgres |
|00001620| 72 65 6c 65 61 73 65 20 | 34 2e 31 2e 0a 0a 48 61 |release |4.1...Ha|
|00001630| 76 65 20 66 75 6e 21 0a | 0a                      |ve fun!.|.       |
+--------+-------------------------+-------------------------+--------+--------+